Social Network Analysis - Amber Heard Case - YouTube

Table of Contents

Introduction

YouTube - Social Network Analysis on Amber Heard's Case

https://stackoverflow.com/questions/24719368/syntaxerror-non-default-argument-follows-default-argument/39942121

Column Definition
etag Record (entity tag); Unique for each record
tl_etag Top Level Comment eTag
tl_id Top Level Comment ID
tl_video_id Top Level Comment Video ID
tl_text Top Level Comment Text
tl_author_display_name Top Level Comment Display name Not Unique
tl_author_channed_id Top Level Comment Channel ID Unique for each Author
tl_n_likes Top Level Comment Number of Likes
tl_comment_puplish_dtime Top Level Comment Number Publish Date Time
tl_comment_update_time Top Level Comment Number Update Date Time
n_replies Number of Replies of each record
replies.comments UNDER INVESTIGATIONS
tl_moderation_status Top Level Comment Moderation Status (Classified Spam or Not)

Exploratory Data Analysis



Exploring Comments Created OVER TIME

Comments Created in Each Year

YouTube was officially launched on December 15, 2005

Comments Created in Each Month

NOTE:

Comments Created in Each Day

Comments Created in Each Day of 2018

Comments Created in Each Day of 2019

Comments Created in Each Day of 2020

Comments Created in Each Day of 2021

Investigate Peaks

NOTE:

Peaks in All Years

2018 Peaks

2019 Peaks

NOTE:

2020 Peaks

2021 Peaks


Exploring Negative Comments

Negative Comments

A Heat Map for the Negative Comments

Top Users with Negative Comments (Only Negative Contributions)

Negative Users Contributions on Each Date

Negative Comments Peak Dates

More Investigations on Top Users Commented Negatively


Victim

A Heat Map for the Comments Containing "Victim"

Top Users with Comments Containing "victim" keyword

"victim" Users Contributions on Each Date

"victim" Peak Dates

More Investigations on Top Users Commented with "victim" Keyword


Comments on Peak Days

Comments on Peak Dates

Peak Dates

2018-07-22 --> (26021 comments)

Fuck off
5

Shut up bitch! If you liked the visual effects in recent movies like Avengers: Infinity War, Black Panther, or Ready Player One, then you’ll be happy to know that the same company is also working on Aquaman ;)
4

Note: Most 2020 peaks are Negative Comments

2020-12-23 --> (20907 comments)

Negative Comments

2018-07-21 --> (18536 comments)

Badass
8

2020-12-27 --> (18206 comments)

Negative Comments

2020-12-24 --> (16771 comments)

Negative Comments

2020-12-22 --> (15584 comments)

Negative Comments

2020-12-26 --> (14771 comments)

Negative Comments

2020-02-04 --> (14349 comments)

Negative Comments

2020-12-28 --> (12246 comments)

Negative Comments

2020-02-07 --> (11204 comments)

Negative Comments

Check 2019 Peaks

Users with The Most Contributions on Each Date

Comments on Peak Hours

Users with The Most Comments on the same hour

Comments on Peak Times

198 Users Commented more than one comment on the same Second

Top Commented Users

Johnny Depp

Lindsey Depp

Users with the Most Likes

Users with the Most Replies

Users with Negative Comments (All Contributions)

A Heat Map for the Negative Users Contributions

Top Users with Negative Comments (All Contributions)

Negative Users Contributions on Each Date

Negative Comments Peak Dates

Most Repeated Comments

Same Text Same Date

Replies

Conclusions

END OF NOTEBOOK